C:/Projekte/RAIS/UI Common/SpecificReportManagement.cs

Go to the documentation of this file.


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Web.UI.WebControls;
using System.Data;

namespace RAIS.UI.Common
{
    public class SpecificReportManagement
    {
        public static Dictionary<string, string> GetSubcategories(string category)
        {
            return ApplicationLogicLayer.SpecificReportManagement.GetSubcategories(category);
        }

        public static bool AddSpecificReport(string specificReportName, string fileName, string reportDefinition, ref int reportID)
        {
            return ApplicationLogicLayer.SpecificReportManagement.AddSpecificReport(specificReportName, fileName, reportDefinition, ref reportID);
        }

        public static Dictionary<string, string> GetReports()
        {
            return ApplicationLogicLayer.SpecificReportManagement.GetReports();
        }

        public static void InitControlsBySpecificReportID(int id, TextBox reportName, DropDownList ddlQuery, DropDownList ddlCategory, DropDownList ddlSubcategory, LinkButton lnkDownload, DropDownList ddlYesNo)
        {
            DataTable dt = ApplicationLogicLayer.SpecificReportManagement.GetReportByID(id);
            if (dt.Rows.Count > 0)
            {
                DataRow row = dt.Rows[0];
                reportName.Text = row["Specific Report Name"].ToString();
                ddlQuery.SelectedIndex = ddlQuery.Items.IndexOf(ddlQuery.Items.FindByText(row["Query Name"].ToString()));
                ddlCategory.SelectedIndex = ddlCategory.Items.IndexOf(ddlCategory.Items.FindByText(row["Category Name"].ToString()));
                ddlSubcategory.Items.Clear();
                foreach (KeyValuePair<string, string> pair in SpecificReportManagement.GetSubcategories(row["Category Name"].ToString()))
                {
                    ddlSubcategory.Items.Add(new ListItem(pair.Value, pair.Key));
                }
                ddlSubcategory.SelectedIndex = ddlSubcategory.Items.IndexOf(ddlSubcategory.Items.FindByValue(row["FK Subcategory ID"].ToString()));
                lnkDownload.Text = row["File Name"].ToString();
                if (ApplicationLogicLayer.SpecificReportManagement.IsMenuItemGenerated(id))
                    ddlYesNo.SelectedIndex = 0;
                else ddlYesNo.SelectedIndex = 1;
            }
        }

        public static bool UpdateSpecificReport(int specificReportID, int maskID, int dynamicMaskID, int subcategoryID, string specificReportName, string fileName, string reportDefinition)
        {
            return ApplicationLogicLayer.SpecificReportManagement.UpdateSpecificReport(specificReportID, maskID, dynamicMaskID, subcategoryID, specificReportName, fileName, reportDefinition);
        }

        public static int GetSubcategoryIDByReportID(int id)
        {
            return ApplicationLogicLayer.SpecificReportManagement.GetSubcategoryIDByReportID(id);
        }

        public static string GetSubcategoryNameByReportID(int id)
        {
            return ApplicationLogicLayer.SpecificReportManagement.GetSubcategoryNameByReportID(id);
        }

        public static bool RemoveSpecificReport(int id, ref string returnMessage)
        {
            return ApplicationLogicLayer.SpecificReportManagement.RemoveSpecificReport(id, ref returnMessage);
        }

        public static byte[] GetSpecificReportFile(int id)
        {
            return ApplicationLogicLayer.SpecificReportManagement.GetSpecificReportFile(id);
        }

        public static string GetSpecificReportDefinition(int reportID)
        {
            return ApplicationLogicLayer.SpecificReportManagement.GetSpecificReportDefinition(reportID);
        }

        public static List<string> GetQueryFieldsByID(int reportID)
        {
            return ApplicationLogicLayer.SpecificReportManagement.GetQueryFieldsByID(reportID);
        }

        public static void SaveReportDefinition(int reportID, string reportDefinition)
        {
            ApplicationLogicLayer.SpecificReportManagement.SaveReportDefinition(reportID, reportDefinition);
        }

        public static bool IsSpecificReport(int dynamicMaskID)
        {
            return ApplicationLogicLayer.SpecificReportManagement.IsSpecificReport(dynamicMaskID);
        }

        public static int GetSpecificReportID(int dynamicMaskID)
        {
            return ApplicationLogicLayer.SpecificReportManagement.GetSpecificReportID(dynamicMaskID);
        }

        public static DataTable GetQueryResult(string queryName, string parameter, string grouping, RAIS.Common.UserManagement.UserData currentUser, int dynamicMaskID)
        {
            return ApplicationLogicLayer.SpecificReportManagement.GetQueryResult(queryName, parameter, grouping, currentUser, dynamicMaskID);
        }

        public static DataTable GetDataTableFromQuery(string query)
        {
            return ApplicationLogicLayer.SpecificReportManagement.GetDataTableFromQuery(query);
        }

        public static List<string> GetSubreports(int reportID)
        {
            return ApplicationLogicLayer.SpecificReportManagement.GetSubreports(reportID);
        }

        public static int GetMaskIdByReportName(string reportName)
        {
            return ApplicationLogicLayer.SpecificReportManagement.GetMaskIdByReportName(reportName);
        }

        public static int GetSpecificReportIdByName(string reportName)
        {
            return ApplicationLogicLayer.SpecificReportManagement.GetSpecificReportIdByName(reportName);
        }

        public static string GetSpecificReportNameById(int specificReportID)
        {
            return ApplicationLogicLayer.SpecificReportManagement.GetSpecificReportNameById(specificReportID);
        }

        public static RAIS.Common.UserManagement.Mask GetMaskByReportName(string specificReportName)
        {
            return ApplicationLogicLayer.SpecificReportManagement.GetMaskByReportName(specificReportName);
        }

        public static bool IsSubreport(string specificReportName)
        {
            return ApplicationLogicLayer.SpecificReportManagement.IsSubreport(specificReportName);
        }

        public static void GenerateMenuItem(int specificReportID, bool generateMenuItem)
        {
            ApplicationLogicLayer.SpecificReportManagement.GenerateMenuItem(specificReportID, generateMenuItem);
        }

        public static void SetQuery(int dynamicMaskID, string queryName)
        {
            ApplicationLogicLayer.SpecificReportManagement.SetQuery(dynamicMaskID, queryName);
        }
    }
}